{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["StartHere","5.ID","Financial information ","SI and regression Pt 1","Current operations Pt2 & Pt3 ","Franchise operations Pt2 & Pt3","Expected Values Pt3","Sheet9"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"StartHere","index":0,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":false,"merged":[[9,2,10,2],[11,2,12,2]]}
[]
[null,"Student Identification Sheet (version5.2)"]
[]
[null,"Name","Melissa salgado"," <<- enter your name here",null,null,"(1)","Add your name to Cell C4 and your Student ID to cell C6. Then  Click [Start Here] to finish loading data."]
[null,null,null,null,null,null,"(2)","Change the file name to include your name. "]
[null,"Student ID",2434822," <<- enter your Student ID here",null,null,"(3)","When done with your work, Click [I'm Done]"]
[null,null,null,null,null,null,"(3)","Upload the file to the applicable iCollege"]
[null,"Date/time",{"$f":"NOW()","v":"2021-04-02T19:04:39.570"},null,null,null,null," assignment folder to receive credit for this workshop/tutorial"]
[null,null,"Spring 2021",null,null,null,"(4)","Never use a file created or started by another student (that is academic dishonesty).\nAll text, codes, writing, data entry, formulas, configuration and instructions must be performed by the individual submitting the work."]
[null,null,"You must use Excel Desktop. Cloud Excel 365 will not work for this class.",null,"2021-04-01T23:34:17.040","Melissa salgado started S01"]
[]
[null,null,"Collaboration Started"]
[]
[null,null,"Individual Challenge started"]
[null,null,"Kurt Schmitz © 2020 Do not post or reproduce."]
[]
[null,"Excel release",{"$f":"INFO(\"release\")","v":"16.0"},"<< Mac Users below 16.24, please update!"]
[null,"OS",{"$f":"INFO(\"OSVERSION\")","v":"Windows (64-bit) NT :.00"},"<< Windows users with version 16.0 are good to go."]

{"sheet":"5.ID","index":1,"n_rows":5,"n_cols":5,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["Do Not Alter or Delete this Worksheet or you submission cannot be graded!",null,null,null,"DirVer"]
["Action","Name","Panther ID","Date/Time","S01"]
["Start S01","Melissa salgado",2434822,"2021-04-01T23:34:17.010","User"]
["Starter Sheet","None",0,"2020-01-01","C:\\Users\\HP\\AppData\\Local\\Temp"]
[null,null,null,null,"Welcome to Microsoft Excel version 16.0 build 4266 running on Windows (64-bit) NT :.00!"]

{"sheet":"Financial information ","index":2,"n_rows":64,"n_cols":26,"rows_kept":64,"cut":false,"hidden":false,"merged":[[36,1,36,2]]}
["Donut Information ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spring 2021"]
["Based on the below data, create the profit model for Donuts to Go.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Melissa salgado"]
["Assume that each customer will buy one donut and one cup of coffee"]
[" "]
[null,null,null,null,null,"Enter totals "]
[null,"Time period",null,null,"Fixed Costs",{"$f":"C11+C13+C17+C18+C19+C14+C20+C21+C23+C25+C26","v":5550}]
["Revenue: Cup of Coffee",null,4,null,"Varible Costs",{"$f":"C9+C15+C16","v":0.85}]
["Revenue: Donut"," ",3.5,null,"Coffee",{"$f":"C15+C16","v":0.35}]
["Donut ingredients per donunt)","per donut",0.5,null,"Donut",{"$f":"C9","v":0.5}]
["paper products: napkins, plates etc"]
["Insurance","month",200]
[" "]
["Maintenance & Repairs to equipment","month",0]
["Marketing & Promotion: Advertising","month",50]
["Coffee ","per cup",0.25]
["Coffee cups ","per cup",0.1]
["Payroll:  Wages (Owner/ Manager)","month",2500]
["Payroll:  Wages (per Employees)","month",1000,null,null,null,null,null," "]
["Donut and Coffee equipment rent ","month",500]
["Professional Fees: Accounting","month",50]
["Professional Fees: Legal","month",25]
["Powdered and Liquid Beverages",null,0]
["Rent","month",1000]
["Previous research expense for Donuts advancements",null,1500]
["Supplies: Office","month",25]
["Utilities","month",200," "]
[" ",null," "]
[]
[]
["Additional Data"]
["Monthly Production","Lost Sales","Day old revenue","High demand, % above Average","Low Demand, % below average"]
[4000,3,1.25,0.22,0.26]
["Franchise "]
["Monthly Fixed Expense increase",7000]
["Monthly Production Increase",0.32]
["Monthly demand increase",0.24]
["States of Natures ","probabilities "]
["High demand",0.2]
["Average demand",0.55000000000000004]
["Low demand",0.25]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Total "]

{"sheet":"SI and regression Pt 1","index":3,"n_rows":102,"n_cols":26,"rows_kept":102,"cut":false,"hidden":false,"merged":[]}
["Month","Demand","Yearly average","Seasonal Index","Average SI","Deseasonalized","Time period",null,null,"Regression Output"]
[1,2302,null,{"$f":"B2/$C$13","v":0.77842590244314824},{"$f":"AVERAGEIF(A$2:A$37,A2,D$2:D$37)","v":0.73978345385053446},{"$f":"B2/E2","v":3111.7213936297298},1,null,"CLICK CELL J2 as output cell for regression",{"$f":"INTERCEPT(F2:F37,Time__period)","v":2775.3436534579396},"Intercept"]
[2,2792.5,null,{"$f":"B3/$C$13","v":0.94428945811142107},{"$f":"AVERAGEIF(A$2:A$37,A3,D$2:D$37)","v":0.84698170510550996},{"$f":"B3/E3","v":3297.0015564292898},2,null,null,{"$f":"SLOPE(F2:F37,Time__period)","v":30.861634922264596},"Slope"]
[3,2454.5,null,0.82999408234001182,0.80703171156512477,3041.3922586013896,3]
[4,3254,null,1.1003466057993068,1.0255014459216618,3173.0818254239434,4]
[5,3586.5,null,{"$f":"B6/$C$13","v":1.2127821455744356},1.0987416470781692,3264.1886375540662,5]
[6,2635.5,null,0.89119959421760087,1.0209225040962251,2581.4887902124215,6]
[7,1986,null,0.67156987065686025,0.76656181294819437,2590.7891137465485,7]
[8,2685,null,0.90793811818412373,0.92259610564011207,2910.2659154810799,8]
[9,2868,null,0.96981993406036016,0.9578435785236542,2994.2258467927641,9]
[10,2948,null,0.99687209400625576,1.0842937621602819,2718.8203998578588,10]
[11,3451.5,"Put yearly average in below cell ",1.1671316256657367,1.2087558175171524,2855.4154197078128,11]
[12,4523.5,{"$f":"AVERAGE(B2:B13)","v":2957.25},1.5296305689407388,1.5209864555933794,2974.0567270438028,12]
[1,2403,null,{"$f":"B14/$C$25","v":0.72807150431752765},0.73978345385053446,3248.247831838506,13]
[2,2473.5,null,{"$f":"B15/$C$25","v":0.74943190425693074},0.84698170510550996,2920.3700447011092,14]
[3,2583.5,null,0.78276018785032575,0.80703171156512477,3201.2372785075127,15]
[4,3362,null,1.0186335403726707,1.0255014459216618,3278.3961576752604,16]
[5,3400.5,null,1.0302984396303589,1.0987416470781692,3094.9040741677409,17]
[6,3628.5,null,1.0993788819875776,1.0209225040962251,3554.1385222104996,18]
[7,2614,null,0.79200121193758521,0.76656181294819437,3410.0315928164541,19]
[8,2979,null,0.90259051658839573,0.92259610564011207,3228.9319039918573,20]
[9,3129,null,0.94803817603393425,0.9578435785236542,3266.712926992524,21]
[10,3912,null,1.1852749583396456,1.0842937621602819,3607.8783596485564,22]
[11,4162.5,"Put yearly average in below cell ",1.261172549613695,1.2087558175171524,3443.6235504950805,23]
[12,4958.5,{"$f":"AVERAGE(B14:B25)","v":3300.5},1.5023481290713527,1.5209864555933794,3260.0553290696794,24]
[1,2695,null,{"$f":"B26/$C$37","v":0.71285295479092725},0.73978345385053446,3642.9579304222943,25]
[2,3203,null,{"$f":"B27/$C$37","v":0.8472237529481782},0.84698170510550996,3781.6637368820107,26]
[3,3056,null,0.80834086450503662,0.80703171156512477,3786.7161304892429,27]
[4,3620,null,0.95752419159300806,1.0255014459216618,3529.9803958311845,28]
[5,3981.5,null,1.0531443560297131,1.0987416470781692,3623.6908017347037,29]
[6,4053.5,null,1.0721890360834967,1.0209225040962251,3970.4286894805732,30]
[7,3161,null,0.83611435625013775,0.76656181294819437,4123.607446401229,31]
[8,3619,null,0.95725968214781665,0.92259610564011207,3922.626572858856,32]
[9,3613,null,0.95567262547666798,0.9578435785236542,3772.0146389338415,33]
[10,4048,null,{"$f":"B35/$C$37","v":1.070734234134944},1.0842937621602819,3733.3056236854181,34]
[11,4529,"Put yearly average in below cell ",1.1979632772720259,1.2087558175171524,3746.8278823284609,35,null,"Use the average seasonal Index  in the column for year 2018"]
[12,5788,{"$f":"AVERAGE(B26:B37)","v":3780.5833333333335},{"$f":"B37/$C$37","v":1.5309806687680472},1.5209864555933794,3805.4250770707481,36,"Deseasonalized forecast","Seasonalized forecast"]
[1,null,null,null,0.73978345385053446,null,37,{"$f":"_xlfn.FORECAST.LINEAR(G38,F$2:F$37,Time__period)","v":3917.2241455817293},{"$f":"H38*E2","v":2897.8976079251606},"When you move your forecast to the profit models, you must use an equation, not just copy the values"]
[2,null,null,null,0.84698170510550996,null,38,3948.0857805039941,{"$f":"H39*E3","v":3343.956426274091}]
[3,null,null,null,0.80703171156512477,null,39,3978.9474154262589,3211.1367428990834]
[4,null,null,null,1.0255014459216618,null,40,4009.8090503485237,4112.0649790021771]
[5,null,null,null,1.0987416470781692,null,41,4040.670685270788,4439.6531640349003]
[6,null,null,null,1.0209225040962251,null,42,4071.5323201930523,4156.7189718402042]
[7,null,null,null,0.76656181294819437,null,43,4102.3939551153171,3144.7385476609111]
[8,null,null,null,0.92259610564011207,null,44,4133.2555900375819,3813.3255109838965]
[9,null,null,null,0.9578435785236542,null,45,4164.1172249598467,3988.5729441475278]
[10,null,null,null,1.0842937621602819,null,46,4194.9788598821106,4548.5894101644235]
[11,null,null,null,1.2087558175171524,null,47,4225.8404948043753,5108.0092819943511]
[12,null,null,null,1.5209864555933794,null,48,4256.7021297266401,{"$f":"H49*E13","v":6474.3862848097115}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Melissa salgado"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spring 2021"]

{"sheet":"Current operations Pt2 & Pt3 ","index":4,"n_rows":201,"n_cols":26,"rows_kept":201,"cut":false,"hidden":false,"merged":[]}
["CURRENT OPERATIONS",null,null,null,"Monthly Production","Lost Sales","Day old revenue",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"test"]
["Part 2",null,null,null,{"$f":"'Financial information '!A32","v":4000},{"$f":"'Financial information '!B32","v":3},{"$f":"'Financial information '!C32","v":1.25},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Summer 2020 "]
["AVERAGE DEMAND"]
["Month ","January","February","March","April","May","June","July","August","September","October","November","December"]
["Demand",{"$f":"'SI and regression Pt 1'!I38","v":2897.8976079251606},{"$f":"'SI and regression Pt 1'!I39","v":3343.956426274091},{"$f":"'SI and regression Pt 1'!I40","v":3211.1367428990834},{"$f":"'SI and regression Pt 1'!I41","v":4112.0649790021771},{"$f":"'SI and regression Pt 1'!I42","v":4439.6531640349003},{"$f":"'SI and regression Pt 1'!I43","v":4156.7189718402042},{"$f":"'SI and regression Pt 1'!I44","v":3144.7385476609111},{"$f":"'SI and regression Pt 1'!I45","v":3813.3255109838965},{"$f":"'SI and regression Pt 1'!I46","v":3988.5729441475278},{"$f":"'SI and regression Pt 1'!I47","v":4548.5894101644235},{"$f":"'SI and regression Pt 1'!I48","v":5108.0092819943511},{"$f":"'SI and regression Pt 1'!I49","v":6474.3862848097115}]
["satisfied demand",{"$f":"MIN($E$2,B5)","v":2897.8976079251606},{"$f":"MIN($E$2,C5)","v":3343.956426274091},3211.1367428990834,4000,4000,4000,3144.7385476609111,3813.3255109838965,3988.5729441475278,4000,4000,4000]
["Extra donuts(over) ",{"$f":"E2-$B$6","v":1102.1023920748394},{"$f":"$E$2-C6","v":656.04357372590903},{"$f":"$E$2-D6","v":788.8632571009166},0,0,0,855.26145233908892,186.67448901610351,11.427055852472222,0,0,0]
["Unsatisfied customers (short)",{"$f":"B5-B6","v":0},{"$f":"C5-C6","v":0},0,112.0649790021771,439.65316403490033,156.71897184020418,0,0,0,548.5894101644235,1108.0092819943511,2474.3862848097115]
["Revenue"]
["coffee ",{"$f":"'Financial information '!$C$7*B6","v":11591.590431700643},{"$f":"'Financial information '!$C$7*C6","v":13375.825705096364},{"$f":"'Financial information '!$C$7*D6","v":12844.546971596334},{"$f":"'Financial information '!$C$7*E6","v":16000},{"$f":"'Financial information '!$C$7*F6","v":16000},{"$f":"'Financial information '!$C$7*G6","v":16000},{"$f":"'Financial information '!$C$7*H6","v":12578.954190643644},{"$f":"'Financial information '!$C$7*I6","v":15253.302043935586},{"$f":"'Financial information '!$C$7*J6","v":15954.291776590111},{"$f":"'Financial information '!$C$7*K6","v":16000},{"$f":"'Financial information '!$C$7*L6","v":16000},{"$f":"'Financial information '!$C$7*M6","v":16000}]
["donut",{"$f":"'Financial information '!$C$8*B6","v":10142.641627738063},{"$f":"'Financial information '!$C$8*C6","v":11703.847491959319},{"$f":"'Financial information '!$C$8*D6","v":11238.978600146791},{"$f":"'Financial information '!$C$8*E6","v":14000},{"$f":"'Financial information '!$C$8*F6","v":14000},{"$f":"'Financial information '!$C$8*G6","v":14000},{"$f":"'Financial information '!$C$8*H6","v":11006.584916813188},{"$f":"'Financial information '!$C$8*I6","v":13346.639288443637},{"$f":"'Financial information '!$C$8*J6","v":13960.005304516348},{"$f":"'Financial information '!$C$8*K6","v":14000},{"$f":"'Financial information '!$C$8*L6","v":14000},{"$f":"'Financial information '!$C$8*M6","v":14000}]
["Revenue from day old sales ",{"$f":"$G$2*B7","v":1377.6279900935492},{"$f":"$G$2*C7","v":820.05446715738628},986.07907137614575,0,0,0,1069.0768154238613,233.34311127012938,14.283819815590277,0,0,0]
["Total Revenue",{"$f":"SUM(B10:B12)","v":23111.860049532253},{"$f":"SUM(C10:C12)","v":25899.727664213071},25069.60464311927,30000,30000,30000,24654.615922880694,28833.284443649354,29928.58090092205,30000,30000,30000]
["Expenses"]
["Fixed Expenses"]
["Total Fixed Expense",{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550}]
[]
["Variable Expenses"]
["Coffee Variable expense",{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1400},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1400},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1400},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1400},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1400},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1400},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1400},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1400},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1400},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1400},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1400},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1400}]
["Donut Variable expense",{"$f":"'Financial information '!$C$9*$E$2","v":2000},{"$f":"'Financial information '!$C$9*$E$2","v":2000},{"$f":"'Financial information '!$C$9*$E$2","v":2000},{"$f":"'Financial information '!$C$9*$E$2","v":2000},{"$f":"'Financial information '!$C$9*$E$2","v":2000},{"$f":"'Financial information '!$C$9*$E$2","v":2000},{"$f":"'Financial information '!$C$9*$E$2","v":2000},{"$f":"'Financial information '!$C$9*$E$2","v":2000},{"$f":"'Financial information '!$C$9*$E$2","v":2000},{"$f":"'Financial information '!$C$9*$E$2","v":2000},{"$f":"'Financial information '!$C$9*$E$2","v":2000},{"$f":"'Financial information '!$C$9*$E$2","v":2000}]
["Total Variable Expenses",{"$f":"B19+B20","v":3400},{"$f":"C19+C20","v":3400},3400,3400,3400,3400,3400,3400,3400,3400,3400,3400]
["Expenses: due to lost sales",{"$f":"$F$2*B8","v":0},{"$f":"$F$2*C8","v":0},0,336.19493700653129,1318.959492104701,{"$f":"$F$2*G8","v":470.15691552061253},0,0,0,1645.7682304932705,3324.0278459830533,7423.1588544291344]
["Total  Expenses",{"$f":"B16+B21+B22","v":8950},{"$f":"C16+C21+C22","v":8950},8950,9286.1949370065304,10268.959492104701,9420.1569155206125,8950,8950,8950,10595.768230493271,12274.027845983053,16373.158854429133]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Yearly Total "]
["Profit Donuts and Coffee",{"$f":"B13-B23","v":14161.860049532253},{"$f":"C13-C23","v":16949.727664213071},16119.60464311927,20713.80506299347,19731.040507895297,20579.843084479387,15704.615922880694,19883.284443649354,20978.58090092205,19404.231769506729,17725.972154016948,13626.841145570867,{"$f":"SUM(B25:M25)","v":215579.40734877938}]
[]
["Part 3","You should be able to copy from average to high and low and then just make some modifications"]
["HIGH DEMAND"]
["Month "]
["Demand"]
["satisfied demand"]
["Extra donuts(over) "]
["Unsatisfied customers (short)"]
["Revenue"]
["coffee "]
["donut"]
["Revenue from day old sales "]
["Total Revenue"]
["Expenses"]
["Fixed Expenses"]
["Total Fixed Expense"]
[]
["Variable Expenses"]
["Coffee Variable expense"]
["Donut Variable expense"]
["Total Variable Expenses"]
["Expenses: due to lost sales"]
["Total  Expenses"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Yearly Total "]
["Profit Donuts and Coffee"]
[]
["Part 3"]
["LOW DEMAND"]
["Month "]
["Demand"]
["satisfied demand"]
["Extra donuts(over) "]
["Unsatisfied customers (short)"]
["Revenue"]
["coffee "]
["donut"]
["Revenue from day old sales "]
["Total Revenue"]
["Expenses"]
["Fixed Expenses"]
["Total Fixed Expense"]
[]
["Variable Expenses"]
["Coffee Variable expense"]
["Donut Variable expense"]
["Total Variable Expenses"]
["Expenses: due to lost sales"]
["Total  Expenses"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Yearly Total "]
["Profit Donuts and Coffee"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Melissa salgado"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spring 2021"]

{"sheet":"Franchise operations Pt2 & Pt3","index":5,"n_rows":75,"n_cols":14,"rows_kept":75,"cut":false,"hidden":false,"merged":[]}
["FRANCHISE",null,null,null,"Monthly Production","Lost Sales","Day old revenue"]
["Part 2",null,null,null,{"$f":"'Financial information '!A32*1.32","v":5280},{"$f":"'Financial information '!B32","v":3},{"$f":"'Financial information '!C32","v":1.25}]
["AVERAGE DEMAND"]
["Month ","January","February","March","April","May","June","July","August","September","October","November","December"]
["Demand",{"$f":"'Current operations Pt2 & Pt3 '!B5*1.24","v":3593.3930338271994},{"$f":"'Current operations Pt2 & Pt3 '!C5*1.24","v":4146.5059685798724},{"$f":"'Current operations Pt2 & Pt3 '!D5*1.24","v":3981.8095611948634},{"$f":"'Current operations Pt2 & Pt3 '!E5*1.24","v":5098.9605739626995},{"$f":"'Current operations Pt2 & Pt3 '!F5*1.24","v":5505.1699234032767},{"$f":"'Current operations Pt2 & Pt3 '!G5*1.24","v":5154.3315250818532},{"$f":"'Current operations Pt2 & Pt3 '!H5*1.24","v":3899.4757990995299},{"$f":"'Current operations Pt2 & Pt3 '!I5*1.24","v":4728.5236336200314},{"$f":"'Current operations Pt2 & Pt3 '!J5*1.24","v":4945.8304507429348},{"$f":"'Current operations Pt2 & Pt3 '!K5*1.24","v":5640.2508686038855},{"$f":"'Current operations Pt2 & Pt3 '!L5*1.24","v":6333.9315096729952},{"$f":"'Current operations Pt2 & Pt3 '!M5*1.24","v":8028.2389931640419}]
["satisfied demand",{"$f":"MIN($E$2,B5)","v":3593.3930338271994},{"$f":"MIN($E$2,C5)","v":4146.5059685798724},{"$f":"MIN($E$2,D5)","v":3981.8095611948634},5098.9605739626995,5280,5154.3315250818532,3899.4757990995299,4728.5236336200314,4945.8304507429348,5280,5280,5280]
["Extra donuts(over) ",{"$f":"$E$2-B6","v":1686.6069661728006},{"$f":"$E$2-C6","v":1133.4940314201276},1298.1904388051366,181.03942603730047,0,125.66847491814679,1380.5242009004701,551.47636637996857,334.16954925706523,0,0,0]
["Unsatisfied customers (short)",{"$f":"B5-B6","v":0},{"$f":"C5-C6","v":0},0,0,225.1699234032767,0,0,0,0,360.25086860388546,1053.9315096729952,2748.2389931640419]
["Revenue"]
["coffee ",{"$f":"'Financial information '!$C$7*B6","v":14373.572135308797},{"$f":"'Financial information '!$C$7*C6","v":16586.02387431949},{"$f":"'Financial information '!$C$7*D6","v":15927.238244779453},{"$f":"'Financial information '!$C$7*E6","v":20395.842295850798},{"$f":"'Financial information '!$C$7*F6","v":21120},{"$f":"'Financial information '!$C$7*G6","v":20617.326100327413},{"$f":"'Financial information '!$C$7*H6","v":15597.90319639812},{"$f":"'Financial information '!$C$7*I6","v":18914.094534480126},{"$f":"'Financial information '!$C$7*J6","v":19783.321802971739},{"$f":"'Financial information '!$C$7*K6","v":21120},{"$f":"'Financial information '!$C$7*L6","v":21120},{"$f":"'Financial information '!$C$7*M6","v":21120}]
["donut",{"$f":"'Financial information '!$C$8*B6","v":12576.875618395197},{"$f":"'Financial information '!$C$8*C6","v":14512.770890029553},{"$f":"'Financial information '!$C$8*D6","v":13936.333464182022},{"$f":"'Financial information '!$C$8*E6","v":17846.362008869448},{"$f":"'Financial information '!$C$8*F6","v":18480},{"$f":"'Financial information '!$C$8*G6","v":18040.160337786485},{"$f":"'Financial information '!$C$8*H6","v":13648.165296848354},{"$f":"'Financial information '!$C$8*I6","v":16549.83271767011},{"$f":"'Financial information '!$C$8*J6","v":17310.406577600272},{"$f":"'Financial information '!$C$8*K6","v":18480},{"$f":"'Financial information '!$C$8*L6","v":18480},{"$f":"'Financial information '!$C$8*M6","v":18480}]
["Revenue from day old sales ",{"$f":"$G$2*B7","v":2108.2587077160006},{"$f":"$G$2*C7","v":1416.8675392751595},1622.7380485064209,226.29928254662559,0,157.08559364768348,1725.6552511255877,689.34545797496071,417.71193657133153,0,0,0]
["Total Revenue",{"$f":"B10+B11+B12","v":29058.706461419992},{"$f":"C10+C11+C12","v":32515.662303624202},31486.309757467898,38468.503587266874,39600,38814.572031761578,30971.723744372059,36153.272710125195,37511.440317143337,39600,39600,39600]
["Expenses"]
["Fixed Expenses"]
["Total Fixed Expense",{"$f":"'Financial information '!$F$6+'Financial information '!$B$34","v":12550},{"$f":"'Financial information '!$F$6+'Financial information '!$B$34","v":12550},{"$f":"'Financial information '!$F$6+'Financial information '!$B$34","v":12550},{"$f":"'Financial information '!$F$6+'Financial information '!$B$34","v":12550},{"$f":"'Financial information '!$F$6+'Financial information '!$B$34","v":12550},{"$f":"'Financial information '!$F$6+'Financial information '!$B$34","v":12550},{"$f":"'Financial information '!$F$6+'Financial information '!$B$34","v":12550},{"$f":"'Financial information '!$F$6+'Financial information '!$B$34","v":12550},{"$f":"'Financial information '!$F$6+'Financial information '!$B$34","v":12550},{"$f":"'Financial information '!$F$6+'Financial information '!$B$34","v":12550},{"$f":"'Financial information '!$F$6+'Financial information '!$B$34","v":12550},{"$f":"'Financial information '!$F$6+'Financial information '!$B$34","v":12550}]
[]
["Variable Expenses"]
["Coffee Variable expense",{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1847.9999999999998},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1847.9999999999998},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1847.9999999999998},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1847.9999999999998},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1847.9999999999998},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1847.9999999999998},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1847.9999999999998},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1847.9999999999998},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1847.9999999999998},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1847.9999999999998},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1847.9999999999998},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1847.9999999999998}]
["Donut Variable expense",{"$f":"'Financial information '!$C$9*$E$2","v":2640},{"$f":"'Financial information '!$C$9*$E$2","v":2640},{"$f":"'Financial information '!$C$9*$E$2","v":2640},{"$f":"'Financial information '!$C$9*$E$2","v":2640},{"$f":"'Financial information '!$C$9*$E$2","v":2640},{"$f":"'Financial information '!$C$9*$E$2","v":2640},{"$f":"'Financial information '!$C$9*$E$2","v":2640},{"$f":"'Financial information '!$C$9*$E$2","v":2640},{"$f":"'Financial information '!$C$9*$E$2","v":2640},{"$f":"'Financial information '!$C$9*$E$2","v":2640},{"$f":"'Financial information '!$C$9*$E$2","v":2640},{"$f":"'Financial information '!$C$9*$E$2","v":2640}]
["Total Variable Expenses",{"$f":"B19+B20","v":4488},{"$f":"C19+C20","v":4488},4488,4488,4488,4488,4488,4488,4488,4488,4488,4488]
["Expenses: due to lost sales",{"$f":"$F$2*B8","v":0},{"$f":"$F$2*C8","v":0},0,0,675.50977020983009,0,0,0,0,1080.7526058116564,3161.7945290189855,8244.7169794921247]
["Total  Expenses",{"$f":"B16+B21+B22","v":17038},{"$f":"C16+C21+C22","v":17038},17038,17038,17713.509770209828,17038,17038,17038,17038,18118.752605811656,20199.794529018985,{"$f":"M16+M21+M22","v":25282.716979492125}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Yearly Total "]
["Profit Donuts and Coffee",{"$f":"B13-B23","v":12020.706461419992},{"$f":"C13-C23","v":15477.662303624202},14448.309757467898,21430.503587266874,21886.490229790172,21776.572031761578,13933.723744372059,19115.272710125195,20473.440317143337,21481.247394188344,19400.205470981015,14317.283020507875,{"$f":"SUM(B25:M25)","v":215761.41702864852}]
[]
["Part 3"]
["HIGH DEMAND"]
["Month "]
["Demand"]
["satisfied demand"]
["Extra donuts(over) "]
["Unsatisfied customers (short)"]
["Revenue"]
["coffee "]
["donut"]
["Revenue from day old sales "]
["Total Revenue"]
["Expenses"]
["Fixed Expenses"]
["Total Fixed Expense"]
[]
["Variable Expenses"]
["Coffee Variable expense"]
["Donut Variable expense"]
["Total Variable Expenses"]
["Expenses: due to lost sales"]
["Total  Expenses"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Yearly Total "]
["Profit Donuts and Coffee"]
[]
["Part 3"]
["LOW DEMAND"]
["Month "]
["Demand"]
["satisfied demand"]
["Extra donuts(over) "]
["Unsatisfied customers (short)"]
["Revenue"]
["coffee "]
["donut"]
["Revenue from day old sales "]
["Total Revenue"]
["Expenses"]
["Fixed Expenses"]
["Total Fixed Expense"]
[]
["Variable Expenses"]
["Coffee Variable expense"]
["Donut Variable expense"]
["Total Variable Expenses"]
["Expenses: due to lost sales"]
["Total  Expenses"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Yearly Total "]
["Profit Donuts and Coffee"]

{"sheet":"Expected Values Pt3","index":6,"n_rows":57,"n_cols":14,"rows_kept":57,"cut":false,"hidden":false,"merged":[[46,2,46,4],[54,2,54,4],[2,2,2,4],[10,2,10,4],[17,2,17,4],[24,2,24,4],[31,2,31,4],[38,2,38,4]]}
[null,"PAYOFF TABLE"]
[]
[null,null,"State of Nature",null,null,null,null,"Summary of Results ","Methods "]
[null,"Decision Alternatives","Low ","Average ","High ",null,null,{"$f":"B4","v":"Decision Alternatives"},"Maximin","MaxiMax","Laplace ","MinMax regret","EVUII","EOL"]
[]
[]
[null,null,null,null,null,null,null,"Decision Alternatives"]
[null,"DM UNDER IGNORANCE"]
[null,null,null,null,null,null,null,"Kiana should choose to:"]
[null,"Maximin"]
[null,null,"State of Nature"]
[null,"Decision Alternatives","Low ","Average ","High ",null,null,"Because:"]
[]
[]
[]
[]
[null,"Maximax"]
[null,null,"State of Nature"]
[null,"Decision Alternatives","Low ","Average ","High "]
[]
[]
[]
[]
[null,"Laplace"]
[null,null,"State of Nature"]
[null,"Decision Alternatives","Low ","Average ","High "]
[]
[]
[]
[]
[null,"Minimax Regret"]
[null,"Regret table","State of Nature"]
[null,"Decision Alternatives","Low ","Average ","High "]
[]
[]
[]
[null,"DM UNDER RISK"]
[null,"EVUII"]
[null,null,"State of Nature"]
[null,"Decision Alternatives","Low ","Average ","High "]
[null,"Probability"]
[]
[]
[]
[]
[null,"EVUPI"]
[null,null,"State of Nature"]
[null,"Decision Alternatives","Low ","Average ","High "]
[null,"Probability"]
[]
[]
[null,"EVPI"]
[]
[null,"EOL"]
[null,"Regret table","State of Nature"]
[null,"Decision Alternatives","Low ","Average ","High "]
[null,"Probability"]

{"sheet":"Sheet9","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}